SELECT DISTINCT(a_id) idp,a_nmb nmb, a_cb idpp,MIN(ap_precio) precio,a_sku sku,aw_departamento dpto,aw_concepto conecpto,a_categoria categoria,aw_inventariado,aw_tienda,aw_ctye,a_modelo,a_marca FROM articulos INNER JOIN articulosw ON a_id = aw_id INNER JOIN categoriasw ON a_categoria = cw_categoria INNER JOIN articulos_precios ON a_id = ap_articulo WHERE a_estatus = "A" AND ap_esquema = "1" AND ap_precio > 0 AND ap_activo = "1" AND aw_tienda IN ("0","1") AND cw_id = "33" GROUP BY a_id ORDER BY aw_visitas DESC, precio ASC